USE [HomestayWebDB]
GO
/****** Object:  StoredProcedure [dbo].[Store_Post_DeleteWishListItemOfUser]    Script Date: 11/26/2012 16:37:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* If user is ban or delete, so they cannot login to use function View WistList
Then don't need to check user status
*/
ALTER PROCEDURE [dbo].[Store_Post_DeleteWishListItemOfUser]
	@PostID int,
	@Username varchar(20)	
AS
BEGIN
	Delete from Wishlists where Wishlists.PostID = @PostID AND Wishlists.Username= @Username 
END
